CREATE EXTERNAL TABLE IF NOT EXISTS spmi_ods.spmi_apack_exp(
id                                                 bigint                         COMMENT '自增ID',
fee_id                                             bigint                         COMMENT '报价ID',
begin_num                                          Double                         COMMENT '条件表达式开始数字',
end_num                                            Double                         COMMENT '条件表达式结束数字',
billing_condition                                  String                         COMMENT '计费条件',
billing_expression                                 String                         COMMENT '计算公式',
billing_type                                       smallint                       COMMENT '计费类型1:W重量 2:P票数',
sort                                               smallint                       COMMENT '排序'
)
COMMENT '中心代建包费报价公式'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/spmi_ods.db/external/spmi_apack_exp'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);